# coding=utf-8
from sqlalchemy import Column, Integer, String, Boolean, BigInteger

from db_models.orm_base import BaseOrmClass


class AppCatTest(BaseOrmClass):
    '''
    模型(表)备注:app cat测试
    '''
    __tablename__ = 'app_cat_test'

    '''   能力 ID   '''
    aid = Column(Integer(), nullable=False)

    '''   应用ID   '''
    appid = Column(Integer(), nullable=False)

    '''   结束时间   '''
    end_time = Column(String(20))

    '''      '''
    id = Column(BigInteger(), primary_key=True)

    '''   得分(0-100之间)   '''
    score = Column(Integer(), nullable=False)

    '''   开始时间   '''
    start_time = Column(String(20), nullable=False)

    '''   状态(0-测试中,1-测试完成)   '''
    status = Column(Boolean(), nullable=False)

    '''   用户 ID   '''
    uid = Column(Integer(), nullable=False)

    def __repr__(self):
        return "app_cat_test(aid='{self.aid}',appid='{self.appid}',score='{self.score}',start_time='{self.start_time}',status='{self.status}',uid='{self.uid}')".format(self=self)

    def exclude(self): return ()
